-- created by kumiler
-- on 2023/1/5 9:21
-- DESC
create external table spmi_dim.dim_spmi_pcp_capacity_cost_mt (
	id bigint  comment '主键id',
	bill_month date  comment '所属月份',
	send_financial_center_name string  comment '寄件财务中心',
	send_financial_center_code string  comment '寄件财务中心编码',
	destination_name string  comment '目的省份',
	destination_code string  comment '目的省份编码',
	cost decimal(12,2)  comment '单公斤成本',
	create_time timestamp  comment '创建时间'
) COMMENT '公斤运力成本'
    PARTITIONED BY (mt string COMMENT '所属月份yyyy-MM')
    stored as parquet
    LOCATION '/dw/hive/spmi_dim.db/external/dim_spmi_pcp_capacity_cost_mt'
;
